# /usr/bin/env python3.6
# -*- encoding: utf-8 -*-
"""
@File    : city_model.py
@Time    : 2020/2/6 0006 14:51
@Author  : zhangbing
@Email   : 18829172841@163.com
@Software: PyCharm
"""
from App.ext import db
from App.models import BaseModel


class Letter(BaseModel):
    letter = db.Column(db.String(1), unique=True)


class City(BaseModel):
    letter_id = db.Column(db.Integer, db.ForeignKey(Letter.id))
    c_id = db.Column(db.Integer, default=0)
    c_parent_id = db.Column(db.Integer, default=0)
    c_region_name = db.Column(db.String(16))
    c_city_code = db.Column(db.Integer, default=0)
    c_pinyin = db.Column(db.String(64))


if __name__ == "__main__":
    pass
